package com.yenlien.traceyun.control.dao;

import com.yenlien.traceyun.control.entity.StoreMan;
import com.yenlien.traceyun.webase.dao.BaseJpaDao;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * @author jialong
 * @date 2021/05/25
 * @description: 仓库管理员数据层
 **/
public interface StoreManDao extends BaseJpaDao<StoreMan> {

    @Query(value = "SELECT `name` FROM store_man WHERE id = ?1", nativeQuery = true)
    String findNameById(int id);


    List<StoreMan> findByCompanyId(String companyId);

}
